The important thing to remember when gathering evidence is that the more evidence the better - that is, the more evidence you gather to demonstrate your skills, the more confident an assessor can be that you have learned the skills not just at one point in time, but are continuing to apply and develop those skills (as opposed to just learning for the test!). Furthermore, one piece of evidence that you collect will not usualy demonstrate all the required criteria for a unit of competency, whereas multiple overlapping pieces of evidence will usually do the trick!
From the Wiki University
What evidence can you provide to prove your understanding of each of the following citeria?
Determine requirements of developing queries
|
|
Identify terminologies applicable to query language Completed |
Evidence:
|
Identify and build queries using required tools and environment Completed |
Evidence:
|
Write queries to extract required information
|
|
Sort and selectively retrieve values through query writing Completed |
Evidence:
|
Aggregate records by multiple attributes using an expression Completed |
Evidence:
|
Sort and filter aggregated records using an expression Completed |
Evidence:
|
Create queries and retrieve records from multiple tables Completed |
Evidence:
|
Retrieve records from multiple tables using different expressions and approaches Completed |
Evidence:
|
Filter records from multiple tables using an expression Completed |
Evidence:
|
Retrieve records from multiple tables using expressions, set operators and set logic Completed |
Evidence:
|
Construct and execute sub-queries Completed |
Evidence:
|
Perform calculations and use expressions in queries
|
|
Perform a calculation on numeric values and an operation on text values using an expression Completed |
Evidence:
|
Perform an operation on date and time values using functions Completed |
Evidence:
|
Aggregate values and obtain required output using an expression Completed |
Evidence:
|
Create and manipulate tables
|
|
Identify required columns, data types, keys, relationships, indexes and constraints Completed |
Evidence:
|
Manipulate tables according to specific requirements Completed |
Evidence:
|
Create and use views and stored procedures
|
|
Create views according to information requirements Completed |
Evidence:
|
Retrieve and save data using a view and transactions Completed |
Evidence:
|
Drop a view from a database Completed |
Evidence:
|
Retrieve, insert and modify data using created and stored procedures according to information requirements Completed |
Evidence:
|
Create and execute stored procedures using one or more parameters Completed |
Evidence:
|
Drop a stored procedure from database Completed |
Evidence:
|
Create and test database triggers and perform specific required data-related functions Completed |
Evidence:
|